UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HTkA1aaPqa2sXKzTG5TUMz35PsrhfpiBXQWO4Qk4kYg='
WHERE
key_id = '78c49dad5f4efc546e08b528fcb6ff7b520ebaae77e1821cadd09bcd9b9e80bf'
AND (
token = 'HTkA1aaPqa2sXKzTG5TUMz35PsrhfpiBXQWO4Qk4kYg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)