UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CnqUzkfwsp7Eg2UBD4Meww+8UFJX2D9zcl8AgIGkIX4='
WHERE
key_id = '31e23d27a77d68b8ec9e3c4c797b44071d2fbaa4f937a4af67895b5ab28375e0'
AND (
token = 'CnqUzkfwsp7Eg2UBD4Meww+8UFJX2D9zcl8AgIGkIX4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)