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