UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SP9IwlHHO56qPdQM2a5IL3YJ7AEGW7pyKq640PlBu6Y='
WHERE
key_id = '7d6b1b71225da1374d3262d86625b24a1ab49b424bbe0708133cf8efa5f305ec'
AND (
token = 'SP9IwlHHO56qPdQM2a5IL3YJ7AEGW7pyKq640PlBu6Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)