UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZSds3F3p3eUYBbohDgp5LV85xzAdeEpqEg9d5YbQeU0='
WHERE
key_id = '9a079ae5a898da4f71d1c786c037bc234a605c2f8c4f773adc92c242bcb2426c'
AND (
token = 'ZSds3F3p3eUYBbohDgp5LV85xzAdeEpqEg9d5YbQeU0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)