UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hIW+q9YSlmfmXzojxqQiJ4+C7JuaKc0RMVNf3Oi7lsA='
WHERE
key_id = '1071f4af8a41ee8cb586fb218a11e791d2b7e0c591ae4968209ede9d0f878e3b'
AND (
token = 'hIW+q9YSlmfmXzojxqQiJ4+C7JuaKc0RMVNf3Oi7lsA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)