UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Kwlg1AcJjY1p/c+TxbtvnSJJ1iOWGzwJ8jWmtsjwUMs='
WHERE
key_id = 'd9ae06b18dade513201125c74171ea06e51a1dcb58aeb19255ebf1e12489df04'
AND (
token = 'Kwlg1AcJjY1p/c+TxbtvnSJJ1iOWGzwJ8jWmtsjwUMs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)