UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HRIrD5h5jfKYxJVqM5P1kkdabr0evBiAjOpWd3u4exU='
WHERE
key_id = '71f93177423b379fa12375336d548d85f9bb5bb93e9e74adfaa8d03b1f2c5c41'
AND (
token = 'HRIrD5h5jfKYxJVqM5P1kkdabr0evBiAjOpWd3u4exU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)