UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aAxQZOyi6c6TCHP6HiJ5nDi5gWvyH+RWe0M9hR15yiI='
WHERE
key_id = '4f04b6ebd1496168be1bca28b17ea6db3547b889081d5bd2f250836fe713bf8a'
AND (
token = 'aAxQZOyi6c6TCHP6HiJ5nDi5gWvyH+RWe0M9hR15yiI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)