UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'f0oNgyKWfy3f7fXR1UAzky/roOXZkpNA1KZXcHfYzvY='
WHERE
key_id = '7197516d752d6331f32c8bb4a8c6cc31396845f811b14992fadfe2cf4c11651e'
AND (
token = 'f0oNgyKWfy3f7fXR1UAzky/roOXZkpNA1KZXcHfYzvY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)