UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'U9ldL2cC/pbCnHYff6P6I3FgYN0dfpuos46GM4TILYM='
WHERE
key_id = 'c64ac7a521b1e69f6346adf82699991401cb6347c0338a12415e8a9bd83df975'
AND (
token = 'U9ldL2cC/pbCnHYff6P6I3FgYN0dfpuos46GM4TILYM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)