UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XYCYLPJgGR4M6c3DY5bLOvsgbUGXSAUZ66GbV/bSScs='
WHERE
key_id = 'dd6df9277558d8d5213653732c84a77b59988a3371b27059defa17764fd7c12b'
AND (
token = 'XYCYLPJgGR4M6c3DY5bLOvsgbUGXSAUZ66GbV/bSScs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)