UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KlwVHy0bn30SJ+XyFrc5M+1h8limFIoSbzGk/VIOWKs='
WHERE
key_id = '23d9350a3388532f96d5eeaddb8f2c1b12c91f0552ae67fe4c11cebbe626fa6a'
AND (
token = 'KlwVHy0bn30SJ+XyFrc5M+1h8limFIoSbzGk/VIOWKs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)