UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fB2aKvHdmG6zPObhlplC2T3IazbA3PILpyjNob2l+WM='
WHERE
key_id = 'b057e0bbc2c87e9e38d48fca5540cc43e0f13a30ea7d8d4d1081cce02b721b25'
AND (
token = 'fB2aKvHdmG6zPObhlplC2T3IazbA3PILpyjNob2l+WM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)