UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7dnX5rQgYjDSny5so9dbFe2i0+lxa+wXPaV3Sz6ltLI='
WHERE
key_id = '55fb10241b1079d93f2de0a9610f133ca741e1fae10458313e6e3259f9214f95'
AND (
token = '7dnX5rQgYjDSny5so9dbFe2i0+lxa+wXPaV3Sz6ltLI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)