UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'khgYkV/7EuiweMsrYzmS8XK9Rji3zfXn2IoM9PKt4f4='
WHERE
key_id = 'e1e6810d87bf5fd94457d5976a27747c2ea662f75c53e13e68e4047755bd290d'
AND (
token = 'khgYkV/7EuiweMsrYzmS8XK9Rji3zfXn2IoM9PKt4f4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)