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