UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HirGxHhFBcIvJEQ0vNWPq+BPQ4grG7qGc426rXsmRE8='
WHERE
key_id = '1e382a42acb7bc7067ebb9f937706059b5e5191ed6df8f0656233787d86497f9'
AND (
token = 'HirGxHhFBcIvJEQ0vNWPq+BPQ4grG7qGc426rXsmRE8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)