UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XXslmv2bsBSnAjJOY+jzJzMnfnQ+KIgBpUELM2mxBhs='
WHERE
key_id = 'c9b606d9220c98cb39d9d85d726516a2514ebe11e8baccbd266244ffb034ef24'
AND (
token = 'XXslmv2bsBSnAjJOY+jzJzMnfnQ+KIgBpUELM2mxBhs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)