UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H2EOhFowRCE4yvHeBfmTLw8VvqIDPSSNflZtV2aH7qs='
WHERE
key_id = '27f959f0755ef9fe37e89ff9c0a9252ee7a8b9a6773bffda6977d47b94499069'
AND (
token = 'H2EOhFowRCE4yvHeBfmTLw8VvqIDPSSNflZtV2aH7qs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)