UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Hd/+9NC6fwFbACQXXqLJEwH0055TiDqz1MIvPSXEfhI='
WHERE
key_id = '46022165320cc457becbb731a35beb0856ec1803f2ddd7c178207af884fc2303'
AND (
token = 'Hd/+9NC6fwFbACQXXqLJEwH0055TiDqz1MIvPSXEfhI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)