UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z4M+oQpMqHtlnWygCJ3QWUMzr/tUFU8co2BUKRHiDiA='
WHERE
key_id = '0cb8ab376b86de42c33a11f5cb01c91276f4c6fe708284498e65e7a849bb1050'
AND (
token = 'z4M+oQpMqHtlnWygCJ3QWUMzr/tUFU8co2BUKRHiDiA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)