UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NO7gPgC+G6CzRbpw5MR7/TsgGOpNalTmkk+r9P7KAMY='
WHERE
key_id = '7c1552fbfe6f0fdb5ebb31ba387b3382bda9d87b3ceeba8427143e7ac10d4c24'
AND (
token = 'NO7gPgC+G6CzRbpw5MR7/TsgGOpNalTmkk+r9P7KAMY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)