UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zQrpVUUNHTSsx1keQi8gjZZI3RHxCGYUqu7O0a3TKno='
WHERE
key_id = 'a332956668afb7aaae38d84dc21604623582635e0015e18efedd0b347b88fa76'
AND (
token = 'zQrpVUUNHTSsx1keQi8gjZZI3RHxCGYUqu7O0a3TKno='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)