UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6x1LJg2K1XtHL1FAJUTxIfec1U8XFAND8CZgAo0/MzM='
WHERE
key_id = 'a0c25da96fe6230d705f009e25b284017b511c8c3505c5d66dfe316b60d02aff'
AND (
token = '6x1LJg2K1XtHL1FAJUTxIfec1U8XFAND8CZgAo0/MzM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)