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