UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7BU2NymRsshJvACbZKwIw5S+WIvQQ/eux3tqRfe4e4w='
WHERE
key_id = '247d658067d073b5ff63446d00a03ef47f813ca24360eb73d85df9517d84a1b1'
AND (
token = '7BU2NymRsshJvACbZKwIw5S+WIvQQ/eux3tqRfe4e4w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)