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