UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XMl5OAahAr9ZWJ04JfV/n4p0hzAm/UwIN/MKwUQYZHY='
WHERE
key_id = '0097306e054201b038ac6d4b5cb61c40fc74913de938bd5869debff9accfd883'
AND (
token = 'XMl5OAahAr9ZWJ04JfV/n4p0hzAm/UwIN/MKwUQYZHY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)