UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KB1yQBfBY394vTpLsZ7+OtK0ntlGSYXZBRvcUvZUOSA='
WHERE
key_id = 'd3b57e776d408cc5fea7b78c5628eabd3297a10c9c284bf1f0b3a4641bf31690'
AND (
token = 'KB1yQBfBY394vTpLsZ7+OtK0ntlGSYXZBRvcUvZUOSA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)