UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'S1LNXQFhOIZBVwrvtvVVmcZrq3PyHYp5OyAD70J5Zas='
WHERE
key_id = '8e96b7ff87cff95bb6ed600240d720fb84be3f4471ddd895bb98819d32efc96b'
AND (
token = 'S1LNXQFhOIZBVwrvtvVVmcZrq3PyHYp5OyAD70J5Zas='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)