UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bhzbLvaK2ZA27QMSaoYeLmEWgXSkNynIlfgBNh+75vY='
WHERE
key_id = 'a6b4b54141d0f196b901648ba791840cb2ccfd1c83dc5e9ae67cd2896a37d8a1'
AND (
token = 'bhzbLvaK2ZA27QMSaoYeLmEWgXSkNynIlfgBNh+75vY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)