UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zPqguOuULJIoloUBE/WuQ6zI07UUExR2SlmTED8InUk='
WHERE
key_id = 'b29f9eef63c64dc46537f8542b819d3a94beb81df65c96e470d5ff1d80cb2c8f'
AND (
token = 'zPqguOuULJIoloUBE/WuQ6zI07UUExR2SlmTED8InUk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)