UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZTz9kHoV1Uk4YKK+T3uRkuAAQlPhIAaKUQ+gqlkVP+w='
WHERE
key_id = 'd77dca03f3b35c9fc8464cf643e611d7d2f9937547762d588c52103fda8a2547'
AND (
token = 'ZTz9kHoV1Uk4YKK+T3uRkuAAQlPhIAaKUQ+gqlkVP+w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)