UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zI7Je6VOGXOtuYZUcO2kwFiBK4GvhrLd7tRYs450WYk='
WHERE
key_id = 'f1d4e2460de218dc69f7c72481c01012341af915120b711aacf0fb46791038dc'
AND (
token = 'zI7Je6VOGXOtuYZUcO2kwFiBK4GvhrLd7tRYs450WYk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)