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